CREATE TABLE [dbo].[tb_AgentesAudit]
(
[idAgenteAudit] [int] NOT NULL IDENTITY(1, 1),
[idAgente] [int] NOT NULL,
[Documento] [int] NOT NULL,
[TipoDocumento] [int] NOT NULL,
[Nombres] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Telefono] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Domicilio] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Localidad] [int] NULL,
[LugarNacimiento] [int] NULL,
[CodPostal] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Sexo] [int] NULL,
[FechaNacimiento] [datetime] NULL,
[CUIT] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EstadoCivil] [int] NULL,
[Nacionalidad] [int] NULL,
[Email] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PercibeJubilacion] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PorcentajeRetiro] [int] NULL,
[AptitudFisica] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FechaApto] [datetime] NULL,
[FechaVencApto] [datetime] NULL,
[EntidadCertificadoraApto] [int] NULL,
[DedicacionExlusiva] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Vive] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FechaAlta] [datetime] NULL,
[Baja] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FechaBaja] [datetime] NULL,
[CausaBaja] [int] NULL,
[FirmaReciboLiq] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TipoJubilacion] [int] NULL,
[LegajoDeInicial] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LegajoDePrimaria] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LegajoDeMedia] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[idAgentePregase] [int] NULL,
[Observaciones] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Apellido] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Nombre] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TipoAgente] [int] NOT NULL,
[NombresMigracion] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CUIL] [bigint] NULL,
[EstadoCUIL] [int] NULL,
[Operacion] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FechaOperacion] [datetime] NOT NULL,
[UsuarioNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__tb_Agente__Usuar__7751F054] DEFAULT (suser_sname())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[tb_AgentesAudit] ADD CONSTRAINT [PK_tb_AgentesAudit] PRIMARY KEY CLUSTERED  ([idAgenteAudit]) ON [PRIMARY]
GO
